Python Job: Data Analyst

Job added on

Location

London, England - United Kingdom

Job type

Full-Time

Python Job Details

Details

Reference number

290485

Salary

£35,425 - £49,150
London: £40,100 to £49,150 / National: £35,425 - £43,900 (Including allowance). Salary is determined by proficiency level assessed at interview.

Job grade

Senior Executive Officer

Contract type

Permanent

Business area

DIT - COO: DDaT

Type of role

Administration / Corporate Support
Analytical
Information Technology
Other

Working pattern

Flexible working, Full-time, Part-time

Number of jobs available

1

Contents

    Location

    About the job

    Benefits

    Things you need to know

    Apply and further information

Location

Cardiff, Darlington, London

About the job

Job summary

This recruitment is continuing as usual, but candidates should be aware that following the Government’s announcement on the changes to some civil service departments, roles will be located in the new Department for Business and Trade. We will provide more information if you are selected for a role. This work remains of high importance to the civil service, and we thank you for your continued interest.

The newly created Department for Business and Trade brings together the business focused functions of the former Department for Business, Energy and Industrial Strategy (BEIS) and the Department for International Trade (DIT). Our joint expertise in trade and business provides us with a unique opportunity to unleash the power of UK businesses, reform regulation to reduce burdens and unlock post-Brexit freedoms.

Job Description

As Data Analyst you will use high quality datasets held inside and outside DBT (Department for Business and Trade) including data and management information, commercial and business data. The department has a relationship with international datasets from Org. for Economic Cooperation and Development, World Bank and UN Comtrade; statistical microdata and large datasets from the Office of National Statistics and Her Majesty’s Revenue and Customs. You will analyse and facilitate the analysis of these datasets, working independently on projects to help DBT get insight from them.

Join our Data Infrastructure team as a Data Analyst and help us transform DBT into an insight-driven organisation that tells compelling stories with its data. You will be based alongside the multidisciplinary team responsible for developing our ground-breaking data and insight platform, Data Workspace. The service gives our staff access to a catalogue of key trade data and a suite of powerful tools with which to analyse and explore it.

This role is available in three UK locations, including central London, Cardiff, and Darlington’s new economic hub. This role can only be worked from within the UK and not overseas. Most DBT employees will be working a hybrid pattern, spending 2-3 days a week (pro rata) in the office on average. Changes to these working arrangements are available in certain circumstances but must be agreed with the vacancy manager and in line with the requirements of the role. Travel to your primary office location will not be paid for by DBT, but costs for travel to an office which is not your main location will be covered.

Find out about life at DBT, our benefits and meet the team by watching our recruitment video, visiting our website or reading our blog!

Job description

Responsibilities

You will be an experienced Data analyst who can:

  • Work in an Agile team and work independently to deliver data analysis projects. During projects, collaborate with colleagues across the business to understand the data insights that would add the most value in their area and work out the best way to meet those needs.
  • Apply tools and techniques for data analysis and data visualisation, working across a broad range of areas such as business intelligence, data assurance and quality.
  • Produce compelling analysis and visualisation of data (e.g., dashboards) to provide actionable insights to technical, policy and operational colleagues.
  • Develop a deep understanding of the systems we use to organise and store data, identifying and assessing new data sources, and investigating and resolving problems as they occur. Use these to manage and maintain data, ensuring it aligns to DBT’s data standards, is protected, and used in line with established governance.
  • Have enthusiasm for helping colleagues to get the maximum value from data. To enable this, you will take a proactive approach to developing your skills and sharing them with others. As part of this you will design and facilitate training for other across the department in the usage of our data analysis tools.

Person specification

Essential Skills and Experience

You will need to have demonstrable skills and experience of:

  • Data visualisation: you should understand how to tell compelling and actionable stories that are relevant to business goals. This will include experience with a dashboarding/BI tool (for example Tableau, Power BI, AWS QuickSight, Google Data Studio, or others).
  • Good communication skills, to communicate accurate information to technical and non-technical stakeholders.
  • Using SQL (Structured query language) to bring data together from different sources and get them ready for analysis using cleaning and preparation techniques.

Desirable Skills and Experience

These are not necessary but would be ideal if you had:

  • Experience using another computer programming language (e.g., Python or R) to bring data together from different sources and get them ready for analysis using cleaning and preparation techniques.
  • Knowledge of project management techniques, particularly using Agile techniques, to manage projects independently.

Personal Attributes and Skills

The ideal candidate will have a passion for solving real-world problems using data and enjoy working in a multi-disciplinary team to deliver results. They will be an effective analyst and a great communicator.

Benefits

  • Learning and development tailored to your role
  • An environment with flexible working options
  • A culture encouraging inclusion and diversity
  • A Civil Service pension with an average employer contribution of 27%

Things you need to know

Selection process details

This vacancy is using Success Profiles, and will assess your Technical Skills and Behaviours.

Interviews for this vacancy will be conducted virtually. We will, however, consider in-person interviews by exception.

Please ensure that you check your emails regularly as all updates from us will be sent to you this way.

Sift will take place week commencing: Monday 5th June 2023

Interviews will take place week commencing: Monday 19th June 2023

Please notes these dates are indicative and may be subject to change.

As part of the application process you will be asked to upload a CV and complete a personal statement outlining your experience, skills and fit for the role.

At the sift stage for this role, we will assess your CV and personal statement against the essential skills and experience listed above. There is no limit on the personal statement, but we recommend writing around 750 words. You can use bullet points and subheadings if you prefer. As well as evidencing the criteria you should also touch upon why you're interested in DBT and in this role.

If we receive a high volume of applications, we will conduct a ‘short sift’ and read one element of your application. For this campaign a short sift would be conducted based on: Personal Statement only.

How you’ll be assessed

At the interview stage for this role, you will be asked to demonstrate relevant technical skills and behaviours from the Success Profiles framework. A role-specific list of these can be found below.

The salary we will offer is determined using interview performance. Scores at interview translate to proficiency levels and an associated salary. Once a successful candidate has a proficiency level and is part of the capability framework, they will be given opportunities to self-assess to progress through the pay scale within their grade during their time at DBT. For further explanation of proficiency levels and more information about DDaT click here. Candidates moving from another government department have the option to retain their current salary.

As part of the ‘Proven IT and mathematical skills’ capability, we will be assessing your SQL knowledge in the interview. This will not be specific to any one tool/database, and you will not be required to do any work outside of the interview related to this.

Technical skills

There will be a technical element within the interview where you will be asked questions about your specific professional skills and knowledge relating directly to the job role.

We will assess you against the following technical skills:

  • Analytical and problem-solving skills.
  • Communication skills
  • Data management
  • Data modelling, data cleansing, and data enrichment skills
  • Data visualisation
  • DDaT standards outside your discipline
  • Logical and creative thinking skills
  • Project management skills
  • Proven IT and mathematical skills
  • Quality assurance, validation, and data linkage abilities
  • Statistical methods and data analysis skills

Detailed explanations of each technical skill can be found on the DDaT Framework.

Behaviours

We will assess you against the following behaviours:

  • Communicating and Influencing
  • Managing a Quality Service
  • Seeing the Big Picture
  • Changing and Improving

Further Information

Appointments may be made to candidates in merit order based on location preferences. Candidates who pass the bar at interview but are not the highest scoring will be held on a 12-month reserve list for future appointments. Candidates who are judged to be a near miss at interview may be offered a post at the grade below the one advertised.

If successful and transferring from another Government Department a criminal record check may be carried out.

The Department for International Trade embraces and values diversity in all forms. We welcome and pride ourselves on the positive impact diversity has on the work we do, and we promote equality of opportunity throughout the organisation.

Harmonised terms and conditions are attached. Please take time to read the document to determine how these may affect you.

Please note – the successful candidate will be expected to remain in post for a minimum of 18 months before being released for another role.

Any move to the Department for International Trade from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may however be eligible for other government schemes, including Tax Free Childcare. Determine your eligibility at https://www.childcarechoices.gov.uk

New entrants are expected to join on the minimum of the pay band.

Reasonable adjustment

If a person with disabilities is put at a substantial disadvantage compared to a non-disabled person, we have a duty to make reasonable changes to our processes.

If you need a change to be made so that you can make your application, you should contact the DDaT Recruitment team before the closing date to discuss your needs.

Our recruitment process is underpinned by appointment on the basis of fair and open competition and appointment on merit, as outlined in the Civil Service Commission's Recruitment Principles.

The Civil Service Code sets out the standards of behaviour expected of civil servants. If you feel your application has not been treated in accordance with these principles and you wish to make a complaint, you should in the first instance contact DBT by email: [email protected].

If you are not satisfied with the response you receive, you can contact the Civil Service Commission, which regulates all Civil Service recruitment. Click here to download a PDF about the Civil Service Commission/Complaints.

If you are experiencing accessibility problems with any attachments on this advert, please contact the email address in the 'Contact point for applicants' section.

For further information and to apply please click the link to direct you to the advertisers website.

Security Clearance Details

This role requires you to undergo Security Clearance. The requirement for SC clearance is to have been present in the UK for at least 3 of the last 5 years. You will be asked to provide evidence of your UK footprint where you have been physically present in the UK. Failure to meet the residency requirements will result in your security clearance application being rejected.

If you require SC clearance you will need to provide evidence of the below requirements.

Checks will be made against:

  • Departmental or company records (personnel files, staff reports, sick leave reports and security records).
  • UK criminal records covering both spent and unspent criminal records.
  • Your credit and financial history with a credit reference agency.
  • Security Services record.
  • Location details.

Feedback will only be provided if you attend an interview or assessment.

Security

Successful candidates must undergo a criminal record check.
Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window).

See our vetting charter (opens in a new window).
People working with government assets must complete baseline personnel security standard (opens in new window) checks.

Nationality requirements

This job is broadly open to the following groups:

  • UK nationals
  • nationals of Commonwealth countries who have the right to work in the UK
  • nationals of the Republic of Ireland
  • nationals from the EU, EEA or Switzerland with settled or pre-settled status or who apply for either status by the deadline of the European Union Settlement Scheme (EUSS) (opens in a new window)
  • relevant EU, EEA, Swiss or Turkish nationals working in the Civil Service
  • relevant EU, EEA, Swiss or Turkish nationals who have built up the right to work in the Civil Service
  • certain family members of the relevant EU, EEA, Swiss or Turkish nationals
Further information on nationality requirements (opens in a new window)

Working for the Civil Service

The Civil Service Code (opens in a new window) sets out the standards of behaviour expected of civil servants.

We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles (opens in a new window).
The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.
The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.

Apply and further information

This vacancy is part of the Great Place to Work for Veterans (opens in a new window) initiative.
The Civil Service welcomes applications from people who have recently left prison or have an unspent conviction. Read more about prison leaver recruitment (opens in new window).
Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Contact point for applicants

Job contact :

Recruitment team

Further information

Our recruitment process is underpinned by the principle of appointment on the basis of fair and open competition and appointment on merit, as outlined in the Civil Service Commissioners’ Recruitment Principles. If you feel your application has not been treated in accordance with these principles and you wish to make a complaint, you should in the first instance contact DIT by email. If you are not satisfied with the response you receive, you can contact the Civil Service Commission, which regulates all Civil Service recruitment. For further information on bringing a complaint to the Civil Service Commission please visit their web pages: Civil Service Commission Complaints